SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Bad{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCity = 'Bad' OR prZip = 'Bad' OR prStreet LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Bad{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCountry = 'Bad') AND (prLocation LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Cannstatt{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCity = 'Cannstatt' OR prZip = 'Cannstatt' OR prStreet LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Cannstatt{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCountry = 'Cannstatt') AND (prLocation LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Germany{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCity = 'Germany' OR prZip = 'Germany' OR prStreet LIKE '{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}Germany{8378349128686a0c6116731178b4ded6ac27eb6db932e9fb4d37c09a35ad7eb4}' OR prCountry = 'Germany')